2013-06-17 - 7717 - Spec - To Run Dumps for BPC #CrystalReportsSupport
SPECIFICATIONS
7717 - To run dumps for BPC
Summary Description
Report need to show Silhouette, Customer, License, SBU, Season, Cost Center, Company, Country, Sales Org, Currency, Fiscal Year, Period, Billing Type and Revenue.
Admin Info
Purpose
|
To run dumps for BPC load.
|
Requested By
|
Ashwin Shantikumar
|
Spec Created By
|
Mallareddy D
|
Spec Created Date
|
06/17/2013
|
Spec QA by
|
Uday Kumar P
|
Objects
|
BPC Report
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
None
Functional Requirement
1. Report has to show Silhouette, Customer, License, SBU, Season, Cost Center, Company, Country, Sales Org, Currency, Fiscal Year, Period, Billing Type and Revenue filelds from BEx Query.
2. SBU field will read the data from "Bussiness Unit" Excel sheet if the SBU Key from BEx matches with SBU Field in sheet, otherwise it will show SBU Key from BEx.
3. Country field will read the data from "Country" Excel sheet if the Country Key from BEx matches with Country Field in sheet, otherwise it will show Country Key from BEx.
4. Customer field will read the data from "Customer" Excel sheet if the Customer Key from BEx matches with Customer Field in sheet, otherwise it will show Customer Key from BEx.
5. Season field will read the data from "Season" Excel sheet if the Season Key from BEx matches with Season Field in sheet otherwise, it will show Season key from BEx.
6. Silhouette field will read the data from "Silhouette" Excel sheet if the Silhouette Key from BEx matches with Silhouette Field in sheet, otherwise it will show Silhouette key from BEx.
7. Cost Center should be blank in the report.
8. All other fields will read the data from BEx query directly.
Solution Summary
1. Need to create BEx query.
2. Need to use the excel sheets provided by NEC.
3. Need to write the formulas as per the given requirement in crystal designer.
Test Plan
Report validation is not required as NEC will validate the output.
Solution Details
1. Need to create BEx query.
2. Need to use the excel sheets given by the client.
3. Need to write the formulas as per the given requirement in crystal designer.
Issues
None